Field

Field Name

Type

Length

Description

1

Payment Batch ID

Character

100

2

Payer Unique ID

Character

100

Required.

3

Payer Name

Character

40

Required.

4

Payer Address Line 1

Character

40

Required.

5

Payer Address Line 2

Character

40

6

Payer Address Line 3

Character

40

7

Payer Address Line 4

Character

40

8

Payer Address City

Character

*

*Columns 8+9+10 should not exceed 40 characters. Required.

9

Payer Address State

Character

*

*Columns 8+9+10 should not exceed 40 characters. Required.

10

Payer Address Zip Code

Character

*

*Columns 8+9+10 should not exceed 40 characters. Required.

11

Payment Bank Account Unique ID

Character

100

12

Payment Check Number

Character

10

Required.

13

Payment Check Date

Date/Time

Refer to format*

Required. *Format: YYYY-MM-DD THH:MM:SS

14

Payment Check Amount

Numeric

14

Required. Up to two decimal places allowed.

15

Payee Unique ID

Character

100

Required.

16

Payee Name

Character

40

Required.

17

Payee Tax ID

Character

100

18

Payee Address Line 1

Character

40

Required. From the Vendors—Address tab, Main Address field (in Vendor Setup).

19

Payee Address Line 2

Character

40

From the Vendors—Address tab, Main Address field (in Vendor Setup).

20

Payee Address Line 3

Character

40

From the Vendors—Address tab, Main Address field (in Vendor Setup).

21

Payee Address Line 4

Character

40

From the Vendors—Address tab, Main Address field (in Vendor Setup).

22

Payee Address Line  City

Character

*

Required.

*Columns 22+23+24 should not exceed 40 characters.

23

Payee Address Line State

Character

*

Required.

*Columns 22+23+24 should not exceed 40 characters.

24

Payee Address Line Postal Code

Character

*

Required.

*Columns 22+23+24 should not exceed 40 characters.

25

Payee Remit To Address Line 1

Character

40

From the Vendors—Mailing tab, Mailing field (in Vendor setup)

26

Payee Remit To Address Line 2

Character

40

From the Vendors—Mailing tab, Mailing field (in Vendor setup)

27

Payee Remit To Address Line 3

Character

40

From the Vendors—Mailing tab, Mailing field (in Vendor setup)

28

Payee Remit To Address Line 4

Character

40

From the Vendors—Mailing tab, Mailing field (in Vendor setup)

29

Payee Remit To Address City

Character

*

*Columns 29+30+31 should not exceed 40 characters.

30

Payee Remit To Address State

Character

*

*Columns 29+30+31 should not exceed 40 characters.

31

Payee Remit To Address Zip Code

Character

*

*Columns 29+30+31 should not exceed 40 characters.

32

Invoice Number

Character

50

Required.

33

Invoice Date

Date/Time

Refer to format.*

Required.

*Format: YYYY-MM-DD THH:MM:SS

34

Invoice Description-Payer Customer Account

Character

30

Required. Invoice Description and Payer Customer Account (separated by a hyphen)

35

Invoice Gross Total Amount

Numeric

14

Required. Up to two decimal places allowed.

36

Invoice Discount Total Amount

Numeric

14

Required. Up to two decimal places allowed.

37

Invoice Net Total Amount

Numeric

14

Required. Up to two decimal places allowed. Invoice amount paid in this check.

38

Payer Customer Account Number

Numeric

100

39

Check Memo

Numeric

255